Relational Database Reverse Engineering: Extraction of an IFO2 Schema
نویسنده
چکیده
The first step for developing an heterogeneous federated database consists in translating local schemas into a canonical data model. This paper offers a method to transform a relational schema into an equivalent object-oriented one. We study in particular the translation of the nary relationship tables (n>2). The canonical data model we are using is the IFO2 data model [16], [17], [24]. We translate a relational schema through a combination of data schema and data instance analysis into three stages : deduction of the IFO2 basic types, deduction of IFO2 edges and functions, deduction of IFO2 fragments.
منابع مشابه
Semiautomatic Generation of Data-Extraction Ontologies from Relational Databases
Data extraction is the process used to gather and structure information in documents (e.g.Web pages). One approach to data extraction is the so-called ontology based data extraction. In this approach, an ontology is used as a guide to the parser that extracts data from the source documents. In this context, an ontology is a conceptual schema enriched with information needed to identify data ite...
متن کاملQuery Pattern-based Relational Data to XML Data Translation Algorithm
This paper proposes a new query pattern-based relational schema-to-XML schema translation (QP-T) algorithm to resolve implicit referential integrity issue. Various translation methods have been introduced on structural aspects and/or semantic aspects. However, most of conventional methods consider only explicit referential integrities specified by relational schema. It causes several problems s...
متن کاملExtraction of Object-oriented Schemas from Existing Relational Databases: a Form-driven Approach
In this paper, we present our Form-driven approach for reverse engineering of relationa databases. This methodology uses the information extracted from both form structure and instances as a database reverse engineering input using an interaction with a user. Through a combination of forms structures and data instances analysis, forms relational sub-schemas and their constraints are derived. Th...
متن کاملEITH - A Unifying Representation for Database Schema and Application Code in Enterprise Knowledge Extraction
The integration of heterogeneous legacy databases requires understanding of database structure and content. We previously developed a theoretical and software infrastructure to support the extraction of schema and business rule information from legacy sources, combining database reverse engineering with semantic analysis of associated application code (DRE/SA). In this paper, we present a compa...
متن کاملOWL Ontology Extraction from Relational Databases via Database Reverse Engineering
The main purpose of the Semantic Web is driving the evolution of the current Web by enabling users to find, share, and combine information more easily. OWL ontologies play a key role in this effort. It is widely believed that the majority of current Web data sources are powered by relational databases (RDB). Thus developing approaches and tools for extracting OWL ontologies from RDB is helpful ...
متن کامل